package src.lshz.servlet;

import src.lshz.JdbcUtils;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet(urlPatterns = "/user/lshzdeleted")
public class UserDeletedServlet extends HttpServlet {
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		// 1. 获取参数
		String id = req.getParameter("id");
		// 2. 执行SQL
		String sql = "DELETE FROM `user` WHERE id = ? AND disabled = 1";
		JdbcUtils.modify(sql, id);
		// 3. 跳转到用户列表页
		resp.sendRedirect("/lshz/user-list.jsp");
	}
}
